/****** Object:  StoredProcedure [dbo].[Ten Most Expensive Products]    Script Date: 06/12/2011 01:42:54 ******/
DROP PROCEDURE [dbo].[Ten Most Expensive Products]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create procedure [dbo].[Ten Most Expensive Products] AS
SET ROWCOUNT 10
SELECT Products.ProductName AS TenMostExpensiveProducts, Products.UnitPrice
FROM Products
ORDER BY Products.UnitPrice DESC
GO
